package model;

import java.io.Serializable;

import javax.persistence.*;

import java.util.Date;

/**
 * The persistent class for the ticket database table.
 * 
 */
@Entity
@Table(name = "ticketsell")
public class Ticketsell implements Serializable {


	/**
	 * 
	 */
	private static final long serialVersionUID = 1L;

	@Id
	@Column(name = "ID")
	public Long id;
	
	@Column(name = "BUSPARK")
	public String buspark;

	public String certificateno;

	public String certificatetype;

	@Column(name = "CREATEBY")
	public Long createby;

	@Temporal(TemporalType.TIMESTAMP)
	@Column(name = "CREATETIME")
	public Date createtime;

	@Column(name = "CUSTOMERID")
	public Long customerid;

	public String customername;

	@Temporal(TemporalType.DATE)
	@Column(name = "DEPARTDATE")
	public Date departdate;

	@Column(name = "DEPARTTIME")
	public String departtime;

	@Column(name = "DISCOUNTRATE")
	public Double discountrate;

	@Column(name = "DISTANCE")
	public Integer distance;

	public String eticketno;

	@Column(name = "FULLPRICE")
	public Double fullprice;

	public Boolean islineschedule;

	public String takestatus;

	public Boolean istakekid;

	public String netticketid;
	
	public String departorgcode;

	public String orderno;

	@Column(name = "PAYMETHOD")
	public String paymethod;

	@Column(name = "Phone")
	public String phone;

	@Column(name = "PRICE")
	public Double price;

	public String printbyname;

	public String reachstationcode;

	public String schedulecode;

	@Column(name = "SCHEDULEPRICEID")
	public Long schedulepriceid;

	@Column(name = "SEATNO")
	public String seatno;

	@Column(name = "SEATTYPE")
	public String seattype;

	@Column(name = "SELLBY")
	public Long sellby;

	@Column(name = "SELLIP")
	public String sellip;

	public String sellorgcode;

	@Temporal(TemporalType.TIMESTAMP)
	@Column(name = "SELLTIME")
	public Date selltime;

	@Column(name = "SELLWAY")
	public String sellway;

	@Column(name = "SERVICEFEE")
	public Double servicefee;

	@Temporal(TemporalType.TIMESTAMP)
	public Date taketime;

	public String takeway;

	@Column(name = "TICKETENTRANCE")
	public String ticketentrance;

	@Column(name = "TICKETNO")
	public String ticketno;

	@Column(name = "TICKETOUTLETS")
	public String ticketoutlets;

	@Column(name = "TICKETSTATUS")
	public String ticketstatus;

	@Column(name = "TICKETTYPE")
	public String tickettype;

	@Column(name = "TOPLIMITPRICE")
	public Double toplimitprice;

	@Column(name = "UPDATEBY")
	public Long updateby;

	@Temporal(TemporalType.TIMESTAMP)
	@Column(name = "UPDATETIME")
	public Date updatetime;

	public String verificationcode;

	public String waitingroom;
	
	public String equipmentproviders;
	
	public String canreturnmoneyback;
	
	public String accountorgcode;
	
	public String seller;
	
	public String paymerchantname;
	public String paymerchantsign;//支付商户标识
	public String paymerchantchannelname;//支付商户渠道名称

	public Ticketsell() {
	}

	public Ticketsell(Long id, String buspark, String certificateno,
			String certificatetype, Long createby, Date createtime,
			Long customerid, String customername, Date departdate,
			String departorgcode, String departtime, Double discountrate,
			Integer distance, String eticketno, Double fullprice,
			boolean islineschedule, String takestatus,
			boolean istakekid, String netticketid,
			String orderno, String paymethod, String phone, Double price,
			String printbyname, String reachstationcode, String schedulecode,
			Long schedulepriceid, String seatno, String seattype, Long sellby,
			String sellip, String sellorgcode, Date selltime, String sellway,
			Double servicefee, Date taketime, String takeway,
			String ticketentrance, String ticketno, String ticketoutlets,
			String ticketstatus, String tickettype, Double toplimitprice,
			Long updateby, Date updatetime, String verificationcode,
			String waitingroom) {
		super();
		this.id = id;
		this.buspark = buspark;
		this.certificateno = certificateno;
		this.certificatetype = certificatetype;
		this.createby = createby;
		this.createtime = createtime;
		this.customerid = customerid;
		this.customername = customername;
		this.departdate = departdate;
		this.departorgcode = departorgcode;
		this.departtime = departtime;
		this.discountrate = discountrate;
		this.distance = distance;
		this.eticketno = eticketno;
		this.fullprice = fullprice;
		this.islineschedule = islineschedule;
		this.takestatus = takestatus;
		this.istakekid = istakekid;
		this.netticketid = netticketid;
		this.orderno = orderno;
		this.paymethod = paymethod;
		this.phone = phone;
		this.price = price;
		this.reachstationcode = reachstationcode;
		this.schedulecode = schedulecode;
		this.schedulepriceid = schedulepriceid;
		this.seatno = seatno;
		this.seattype = seattype;
		this.sellby = sellby;
		this.sellip = sellip;
		this.sellorgcode = sellorgcode;
		this.selltime = selltime;
		this.sellway = sellway;
		this.servicefee = servicefee;
		this.taketime = taketime;
		this.takeway = takeway;
		this.ticketentrance = ticketentrance;
		this.ticketno = ticketno;
		this.ticketoutlets = ticketoutlets;
		this.ticketstatus = ticketstatus;
		this.tickettype = tickettype;
		this.toplimitprice = toplimitprice;
		this.updateby = updateby;
		this.updatetime = updatetime;
		this.verificationcode = verificationcode;
		this.waitingroom = waitingroom;
	}
	
	

}